問1
CREATE TABLE book_table (book_id INT,book_name VARCHAR(50),author_name VARCHAR(50),price INT,sales_flag INT );

問2
INSERT INTO book_table VALUES(10001, 'TwoPeace','三田英一郎',420,1);
INSERT INTO book_table VALUES(10002, '名探偵金田二','青山ふみや',460,1);
INSERT INTO book_table VALUES(20001, '坊ちゃま','冬目漱岩',460,1);
INSERT INTO book_table VALUES(30001, '西方見聞録','不明',1000,1);
INSERT INTO book_table VALUES(40010, '吾輩は犬である','冬目漱岩',420,1);

SELECT * FROM book_table;

問3
SELECT book_name,author_name FROM book_table;

問4
UPDATE book_table SET sales_flag =  0 WHERE book_id = 30001;

問5
SELECT book_id, book_name, author_name,price, sales_flag FROM book_table where sales_flag = 1;

問6
SELECT book_id, book_name, author_name,price, sales_flag FROM book_table where author_name = '冬目漱岩' AND price = 420;

問7
DELETE FROM book_table WHERE book_id = 20001;

